AdStudentTransferHeader

Logical Entity Name | AdStudentTransferHeader
Default Table Name | AdStudentTransferHeader
Physical Only | NO
Owner | dbo
Definition |
Note |

AdStudentTransferHeader Columns

ColumnName | Domain | Datatype | NULL | Definition
SyStudentID |  | int | NO |
FromAdEnrollID |  | int | NO |
ToAdEnrollID |  | int | YES |
FromSyCampusID |  | int | NO |
ToSyCampusID |  | int | NO |
FromAdProgramVersionID |  | int | NO |
ToAdProgramVersionID |  | int | NO |
MoveDateBilled |  | bit | NO |
MoveStartDate |  | bit | NO |
MoveLDA |  | bit | NO |
MoveCourses |  | char(1) | NO |
PerformDocReview |  | bit | NO |
FaCmTemplateID |  | int | YES |
FaSyStaffID |  | int | YES |
SaCmTemplateID |  | int | YES |
SaSyStaffID |  | int | YES |
SyGroupsID |  | int | YES |
ProcessDate |  | datetime | NO |
ProcessThis |  | bit | NO |
Processed |  | bit | NO |
Reversed |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
Ts |  | timestamp | NO |
ModifyFees |  | bit | NO |
AdStudentTransferHeaderID |  | int | NO |
MoveFA |  | bit | NO |
MoveBudget |  | bit | NO |

AdStudentTransferHeader Primary and Unique Keys

Key Name | Key Type | Keys
AdStudentTransferHeader_AdStudentTransferHeaderID_U_C_IDX | PrimaryKey | AdStudentTransferHeaderID

AdStudentTransferHeader Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
CmTemplate | Non-Identifying | Zero or One to Zero or More | FK_AdStudentTransferHeader_FaCmTemplateID_CmTemplate_CmTemplateID |  |  | FaCmTemplateID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_AdStudentTransferHeader_FaSyStaffID_SyStaff_SyStaffID |  |  | FaSyStaffID | NO | YES
AdEnroll | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromAdEnrollID_AdEnroll_AdEnrollID |  |  | FromAdEnrollID | NO | YES
AdProgramVersion | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromAdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  | FromAdProgramVersionID | NO | YES
SyCampus | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromSyCampusID_SyCampus_SyCampusID |  |  | FromSyCampusID | NO | YES
CmTemplate | Non-Identifying | Zero or One to Zero or More | FK_AdStudentTransferHeader_SaCmTemplateID_CmTemplate_CmTemplateID |  |  | SaCmTemplateID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_AdStudentTransferHeader_SaSyStaffID_SyStaff_SyStaffID |  |  | SaSyStaffID | NO | YES
syStudent | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_SyStudentID_syStudent_SyStudentID |  |  | SyStudentID | NO | YES
AdEnroll | Non-Identifying | Zero or One to Zero or More | FK_AdStudentTransferHeader_ToAdEnrollID_AdEnroll_AdEnrollID |  |  | ToAdEnrollID | NO | YES
AdProgramVersion | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_ToAdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  | ToAdProgramVersionID | NO | YES
SyCampus | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_ToSyCampusID_SyCampus_SyCampusID |  |  | ToSyCampusID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdStudentTransferCourses | Identifying | One To Zero or More | FK_AdStudentTransferCourses_AdStudentTransferHeaderID_AdStudentTransferHeader_AdStudentTransferHeaderID |  |  |  | NO | YES
AdStudentTransferDocuments | Identifying | One To Zero or More | FK_AdStudentTransferDocuments_AdStudentTransferHeaderID_AdStudentTransferHeader_AdStudentTransferHeaderID |  |  |  | NO | YES

AdStudentTransferHeader Check Constraints

Check Constraint Name | CheckConstraint

AdStudentTransferHeader Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AdStudentTransferHeader Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentPeriodTransfer | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdStudentTransferHeader | NO |  |  |

AdStudentTransferHeader Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | StudentEnrollment
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdStudentTransferHeader Data Movement Rules

Name | Type | Rule Text/Value